/** Copyright 2014, Ross Mahony. Some rights reserved. See COPYING. */
package utils

import java.text.SimpleDateFormat
import play.api._
import models._
import play.api.db.slick._
import play.api.Play.current

/**
 * Initial set of data to be imported in the sample application.
 */
object InitialData {

  val sdf = new SimpleDateFormat("yyyy-MM-dd")

 /** Populate the database with data */
  def insert() {
    DB.withSession { implicit s:Session =>
      if (MeasureDAO.count == 0) {
        Seq(
          Measure(Option(1L), "Boiler Replacement", 310.00, 2500.00, 1200.00),
          Measure(Option(2L), "Thermostat", 70.00, 0.00, 170.00),
          Measure(Option(3L), "Water Cylinder Insulation", 45.00, 50.00, 170.00),
          Measure(Option(4L), "Loft Insulation (0 – 270mm)", 180.00, 300.00, 110.00),
          Measure(Option(5L), "Loft Insulation (100 – 270mm)", 30.00, 300.00, 110.00),
          Measure(Option(6L), "Cavity Wall Insulation", 140.00, 500.00, 560.00),
          Measure(Option(7L), "Solid Wall Insulation (Internal)", 460.00, 7000.00, 1800.00),
          Measure(Option(8L), "Solid Wall Insulation (External)", 490.00, 11000.00, 1900.00),
          Measure(Option(9L), "Floor Insulation", 60.00, 530.00, 240.00),
          Measure(Option(10L), "Draught Proofing", 55.00, 200.00, 150.00),
          Measure(Option(11L), "Double Glazing", 170.00, 300.00, 680.00),
          Measure(Option(12L), "Solar water heating", 60.00, 4800.00, 230.00),
          Measure(Option(13L), "Photovoltaics", 785.00, 7000.00, 1400.00)
        ).foreach(MeasureDAO.forceInsert)
        
        Seq(
          Property(Option(1L), "BN15 9SQ", 0, "1920 - 1945", 0, 2),
          Property(Option(2L), "BN15 9SQ", 0, "1920 - 1945", 0, 3),
          Property(Option(3L), "BN15 9SQ", 0, "1920 - 1945", 1, 3),
          Property(Option(4L), "BN15 9SQ", 1, "1946 - 1954", 1, 3),
          Property(Option(5L), "BN15 9SQ", 0, "1920 - 1945", 0, 3)
        ).foreach(PropertyDAO.forceInsert)

        Seq(
          Customer(Option(1L), "Aleshia", "Tomkiewicz", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "St. Stephens Ward", "Kent", "BN15 9SQ"),
          Customer(Option(2L), "Evan", "Zigomalas", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Abbey Ward", "Buckinghamshire", "TR26 2QP"),
          Customer(Option(3L), "France", "Andrade", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "East Southbourne and Tuckton W", "Bournemouth", "PL26 8FF"),
          Customer(Option(4L), "Tyisha", "Veness", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Greets Green and Lyng Ward", "West Midlands", "DE22 3QH"),
          Customer(Option(5L), "Eric", "Rampy", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Desborough", "Northamptonshire", "X11 7HX"),
          Customer(Option(6L), "Marg", "Grasmick", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Bargate Ward", "Southampton", "TW3 1PJ"),
          Customer(Option(7L), "Laquita", "Hisaw", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Chirton Ward", "Tyne &amp; Wear", "PO15 7GF"),
          Customer(Option(8L), "Lura", "Manzella", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Staple Hill Ward", "South Gloucestershire", "CA15 8DL"),
          Customer(Option(9L), "Yuette", "Klapec", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Parwich", "Derbyshire", "CM77 8JJ"),
          Customer(Option(10L), "Fernanda", "Writer", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Wilmington", "Kent", "PO14 1QD"),
          Customer(Option(11L), "Charlesetta", "Erm", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Loundsley Green Ward", "Derbyshire", "CA14 4ND"),
          Customer(Option(12L), "Corrinne", "Jaret", "0800 316 8558", "devchallenge@npower.com", "1 Bridgwater Road", "Dee Ward", "Dumfries and Galloway", "CA14 5AG")
        ).foreach(CustomerDAO.forceInsert)

        Seq(
          Roadmap(1L, "Silver", 2500.00, sdf.parse("2014-04-01"), None)
        ).foreach(RoadmapDAO.forceInsert)

        Seq(
          RoadmapMeasure(Option(1L), 1L, "Completed", 310.00, 2500.00, 1200.00),
          RoadmapMeasure(Option(1L), 2L, "Completed", 70.00, 0.00, 170.00),
          RoadmapMeasure(Option(1L), 3L, "Completed", 45.00, 50.00, 170.00),
          RoadmapMeasure(Option(1L), 4L, "In-progress", 180.00, 300.00, 110.00),
          RoadmapMeasure(Option(1L), 5L, "In-progress", 30.00, 300.00, 110.00)
        ).foreach(RoadmapDAO.forceInsertMeasure)

        Seq(
          RoadmapDiscount(Option(1L), "Green Deal Energy Loan", 1000.00, "This is a loan that will be paid over 25 years through standard energy bill"),
          // RoadmapDiscount(Option(1L), "Solar thermal panels RHI", 537.60, "Tariff 19.2 p/kWh"),
          // RoadmapDiscount(Option(1L), "The Warm Home Discount", 140.00, ""),
          // RoadmapDiscount(Option(1L), "Cold Weather Payment", 140.00, ""),
          // RoadmapDiscount(Option(1L), "The Warm Home Discount", 150.00, "£25 for each 7 day period of very cold weather "),
          RoadmapDiscount(Option(1L), "Free boiler", 1800.00, "ECO Funding")
        ).foreach(RoadmapDAO.forceInsertDiscount)

        Seq(
          Tip(Option(1L), "Turn off all standby appliances", 
            """Unplugging a device constantly consuming standby power saves a yearly 
              9 kWh for each watt of continuous consumption. This is for each apppliance, 
              I have quite a few devices that are on standby and have found I have reduced 
              my energy consumption and cost by quite a lot.
            """, 4),
          Tip(Option(2L), "Set your washing machine temperature to wash at 30°C", 
            """According to the Energy Saving Trust washing clothes at 30°C uses around 40% less
              electricity over a year than washing at higher temperatures, saving around £13 
              annually on energy bills.
            """, 1),
          Tip(Option(3L), "Invest in an energy-efficient kettle", 
            """Kettles all use a similar amount of energy to boil a litre of water, but that doesn’t
              mean they’re all equally efficient. Kettles can help you save energy and money if they 
              don’t remain switched on after the water has boiled and if they have a low minimum fill
              level, as this means you don’t have to boil more water than you need.
              People on average boil their kettle 4 times a day. If you fill a kettle full (8 cups) it
              will take around 10 minutes to boil and if you calculate this for the full year, it will
              cost you and approximately £58 per year just to run your kettle. If you were to just fill 
              the kettle for 2 cups each time you boiled it, it would only take around 2 minutes to boil,
              if you calculate this for the full year it will cost you around £11.
            """, 3),
          Tip(Option(4L), "An electrical shower uses less energy to heat your water", 
            """I use the shower a lot more than I do the bath. For a small price I replaced my normal
              shower with an electrical one which only heats the water I use plus I have an aerating 
              water-efficient shower head to not waste any water but still get the right amount of
              power that I like.
            """, 1),
          Tip(Option(5L), "Energy Saving Light Bulbs can save you up to £10 a year", 
            """Energy Saving Light Bulbs can save you up to £10 a year.
            """, 4),
          Tip(Option(6L), "Saved about £10 a year on insulating my hot water tank", 
            """Saved about £10 a year on insulating my hot water tank.
            """, 5),
          Tip(Option(7L), "You can save approximately £130 a year with cavity wall insulation.",
            """You can save approximately £130 a year with cavity wall insulation.
            """, 6),
          Tip(Option(8L), "What's the best way to save energy at home?", 
            """I have a 2 bedroom flat and would like to know what are the best ways to save energry in my home?
            """, 7),
          Tip(Option(9L), "Which appliances use the most electricity?", 
            """I would like to know which appliances use the most electricity?
            """, 8),
          Tip(Option(10L), "Do computers and TVs use electricity even when they're turned off?", 
            """Do computers and TVs use electricity even when they're turned off?
            """, 9)
        ).foreach(TipDAO.insert)

        Seq(
          TipComment(Option(1L), 1L, 2L, 
            """I bought a SMJ triple remote control plug set for just £20.00, these plugs allows 
             you to switch appliances off at the mains using a remote control. I saved at least
             £30 a year because of this.
            """),
          TipComment(Option(2L), 1L, 3L, 
            """It is also worth looking at the TreeGreen energyEgg. It costs around £40.00. It uses
              a motion detector to switch things on and off when you enter or leave a room. TreeGreen
              claims the energyEgg will pay for itself in about six months and suggest consumers use 
              its online energy saving calculator to estimate the payback time. It also comes with a 
              six-month 100% money back guarantee.
            """),
          TipComment(Option(3L), 2L, 4L, 
            """Detergent manufacturers say a cooler wash is kinder to your clothes, reducing colour 
              loss and fabric damage. 
            """),
          TipComment(Option(4L), 2L, 2L, 
            """A 30°C wash won't remove heavy stains and is not hot enough to thoroughly clean towels.
              If you want to be sure of killing dust mites you will need to wash at 60°C."
            """),
          TipComment(Option(5L), 3L, 1L, 
            """Here's a link to some of the top energy saving kettles on the market along with their reciews
              http://www.which.co.uk/energy/energy-saving-products/reviews-ns/energy-saving-appliances/best-energy-saving-kettles/
            """),
          TipComment(Option(6L), 4L, 2L, 
            """Some water companies are giving shower heads away for free
            """),
          TipComment(Option(7L), 4L, 2L, 
            """Electricity is generally charged at about 12p per KWh, so for a 10 minute shower using a 7.5kw
              shower would cost 15p. A power shower could use around 15litres/min, so a 10 min shower would 
              use 150 litres of mains water, heated from around 8°C to 30°C.

              Gas would cost 23p to heat this water, Using an oil boiler, this would be around 28p, and if 
              using electricity (Immersion heater), the cost would be 46p.
            """),
          TipComment(Option(8L), 8L, 1L, 
            """Lowering your thermostat by a few degrees can make a big difference.
            """),
          TipComment(Option(9L), 9L, 3L, 
            """Of all the big appliances in your house, the refrigerator uses the most electricity. 
              Other big energy users are water heaters, clothes dryers, dishwashers and ovens.
            """),
          TipComment(Option(10L), 10L, 5L, 
            """Computers, TVs, DVD players and microwaves use electricity to power the clock and remember all
             the settings you program into them.
            """)
        ).foreach(TipDAO.insertComment)

        Seq(
          EnergyUsage(1L, 1, sdf.parse("2008-01-01"), sdf.parse("2008-12-31"), 3700.00, 0.12992000, "E"),
          EnergyUsage(2L, 1, sdf.parse("2009-01-01"), sdf.parse("2009-12-31"), 3715.00, 0.13000000, "E"),  
          EnergyUsage(3L, 1, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 3699.00, 0.13212000, "E"),
          EnergyUsage(4L, 1, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 4222.00, 0.13251000, "E"),  
          EnergyUsage(5L, 1, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 3700.00, 0.13550000, "E"),
          EnergyUsage(6L, 1, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 3729.00, 0.13692000, "E"), 
          EnergyUsage(7L, 1, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 30915.00, 0.05453500, "G"),
          EnergyUsage(8L, 1, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 30905.00, 0.05693500, "G"),  
          EnergyUsage(9L, 1, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 30890.00, 0.05903500, "G"),
          EnergyUsage(10L, 1, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 30920.00, 0.05953500, "G"),
          EnergyUsage(11L, 2, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 1200.00, 0.11182500, "E"),
          EnergyUsage(12L, 2, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 840.00, 0.11182500, "E"),
          EnergyUsage(13L, 2, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 815.00, 0.11182500, "E"),
          EnergyUsage(14L, 2, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 863.00, 0.11182500, "E"),
          EnergyUsage(15L, 2, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 7999.00, 0.05879000, "G"),
          EnergyUsage(16L, 2, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 8100.00, 0.05889000, "G"),
          EnergyUsage(17L, 2, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 8510.00, 0.05900000, "G"),
          EnergyUsage(18L, 2, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 8309.00, 0.05922000, "G"),
          EnergyUsage(19L, 4, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 790.00, 0.11182500, "E"),
          EnergyUsage(20L, 4, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 750.00, 0.11182500, "E"),
          EnergyUsage(21L, 4, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 790.00, 0.11182500, "E"),
          EnergyUsage(22L, 4, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 732.00, 0.11182500, "E"),
          EnergyUsage(23L, 4, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 6098.00, 0.05879000, "G"),
          EnergyUsage(24L, 4, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 6120.00, 0.05889000, "G"),
          EnergyUsage(25L, 4, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 6400.00, 0.05900000, "G"),
          EnergyUsage(26L, 4, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 6631.00, 0.05922000, "G"),
          EnergyUsage(27L, 5, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 5976.00, 0.11182500, "E"),
          EnergyUsage(28L, 5, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 5986.00, 0.11182500, "E"),
          EnergyUsage(29L, 5, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 5469.00, 0.11182500, "E"),
          EnergyUsage(30L, 5, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 5796.00, 0.11182500, "E"),
          EnergyUsage(31L, 5, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 205.00, 0.05879000, "G"),
          EnergyUsage(32L, 5, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 195.00, 0.05889000, "G"),
          EnergyUsage(33L, 5, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 208.00, 0.05900000, "G"),
          EnergyUsage(34L, 5, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 219.00, 0.05922000, "G"),
          EnergyUsage(35L, 6, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 1789.00, 0.11182500, "E"),
          EnergyUsage(36L, 6, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 1867.00, 0.11182500, "E"),
          EnergyUsage(37L, 6, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 1976.00, 0.11182500, "E"),
          EnergyUsage(38L, 6, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 1817.00, 0.11182500, "E"),
          EnergyUsage(39L, 6, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 3975.00, 0.05879000, "G"),
          EnergyUsage(40L, 6, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 4321.00, 0.05889000, "G"),
          EnergyUsage(41L, 6, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 4890.00, 0.05900000, "G"),
          EnergyUsage(42L, 6, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 4577.00, 0.05922000, "G"),
          EnergyUsage(43L, 7, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 4312.00, 0.11182500, "E"),
          EnergyUsage(44L, 7, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 4345.00, 0.11182500, "E"),
          EnergyUsage(45L, 7, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 4002.00, 0.11182500, "E"),
          EnergyUsage(46L, 7, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 4458.00, 0.11182500, "E"),
          EnergyUsage(47L, 7, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 3245.00, 0.05879000, "G"),
          EnergyUsage(48L, 7, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 3120.00, 0.05889000, "G"),
          EnergyUsage(49L, 7, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 3890.00, 0.05900000, "G"),
          EnergyUsage(50L, 7, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 3410.00, 0.05922000, "G"),
          EnergyUsage(51L, 8, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 3010.00, 0.11182500, "E"),
          EnergyUsage(52L, 8, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 2300.00, 0.11182500, "E"),
          EnergyUsage(53L, 8, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 2590.00, 0.11182500, "E"),
          EnergyUsage(54L, 8, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 2902.00, 0.11182500, "E"),
          EnergyUsage(55L, 8, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 782229.00, 0.05879000, "G"),
          EnergyUsage(56L, 8, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 833309.00, 0.05889000, "G"),
          EnergyUsage(57L, 8, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 941833.00, 0.05900000, "G"),
          EnergyUsage(58L, 8, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 1318334.00, 0.05922000, "G"),
          EnergyUsage(59L, 9, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 7892.00, 0.11182500, "E"),
          EnergyUsage(60L, 9, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 7452.00, 0.11182500, "E"),
          EnergyUsage(61L, 9, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 8230.00, 0.11182500, "E"),
          EnergyUsage(62L, 9, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 7956.00, 0.11182500, "E"),
          EnergyUsage(63L, 9, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 189.00, 0.05879000, "G"),
          EnergyUsage(64L, 9, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 230.00, 0.05889000, "G"),
          EnergyUsage(65L, 9, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 85.00, 0.05900000, "G"),
          EnergyUsage(66L, 9, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 145.00, 0.05922000, "G"),
          EnergyUsage(67L, 10, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 2105.00, 0.11182500, "E"),
          EnergyUsage(68L, 10, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 2400.00, 0.11182500, "E"),
          EnergyUsage(69L, 10, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 1980.00, 0.11182500, "E"),
          EnergyUsage(70L, 10, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 2343.00, 0.11182500, "E"),
          EnergyUsage(71L, 10, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 2343.00, 0.05879000, "G"),
          EnergyUsage(72L, 10, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 1234.00, 0.05889000, "G"),
          EnergyUsage(73L, 10, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 3022.00, 0.05900000, "G"),
          EnergyUsage(74L, 10, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 5623.00, 0.05922000, "G"),
          EnergyUsage(75L, 11, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 2933.00, 0.11182500, "E"),
          EnergyUsage(76L, 11, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 2891.00, 0.11182500, "E"),
          EnergyUsage(77L, 11, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 2109.00, 0.11182500, "E"),
          EnergyUsage(78L, 11, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 2487.00, 0.11182500, "E"),
          EnergyUsage(79L, 11, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 11312.00, 0.05879000, "G"),
          EnergyUsage(80L, 11, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 11004.00, 0.05889000, "G"),
          EnergyUsage(81L, 11, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 11789.00, 0.05900000, "G"),
          EnergyUsage(82L, 11, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 11614.00, 0.05922000, "G"),
          EnergyUsage(83L, 12, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 3980.00, 0.11182500, "E"),
          EnergyUsage(84L, 12, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 4609.00, 0.11182500, "E"),
          EnergyUsage(85L, 12, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 3539.00, 0.11182500, "E"),
          EnergyUsage(86L, 12, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 5196.00, 0.11182500, "E"),
          EnergyUsage(87L, 12, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 22500.00, 0.05879000, "G"),
          EnergyUsage(88L, 12, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 19822.00, 0.05889000, "G"),
          EnergyUsage(89L, 12, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 28755.00, 0.05900000, "G"),
          EnergyUsage(90L, 12, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 23698.00, 0.05922000, "G"),
          EnergyUsage(91L, 3, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 8800.00, 0.11182500, "E"),
          EnergyUsage(92L, 3, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 7500.00, 0.11182500, "E"),
          EnergyUsage(93L, 3, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 8000.00, 0.11182500, "E"),
          EnergyUsage(94L, 3, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 8954.00, 0.11182500, "E"),
          EnergyUsage(95L, 3, sdf.parse("2010-01-01"), sdf.parse("2010-12-31"), 15810.00, 0.05879000, "G"),
          EnergyUsage(96L, 3, sdf.parse("2011-01-01"), sdf.parse("2011-12-31"), 15100.00, 0.05889000, "G"),
          EnergyUsage(97L, 3, sdf.parse("2012-01-01"), sdf.parse("2012-12-31"), 15800.00, 0.05900000, "G"),
          EnergyUsage(98L, 3, sdf.parse("2013-01-01"), sdf.parse("2013-12-31"), 15221.00, 0.05922000, "G")
        ).foreach(EnergyUsageDAO.forceInsert)
      }
    }  
  }
}



